
USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[LeagueSelect]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.LeagueSelect
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 11/03/08
-- Description:	League Select
-- =============================================
CREATE PROCEDURE LeagueSelect

		   
AS
BEGIN

SELECT LeagueId, LeagueName FROM Leagues
ORDER BY LeagueId DESC

END
GO

--    LeagueSelect